home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 4 / developer source - volume 4.iso / dbmsa / feb96 / parkf103.gif < prev    next >
Graphics Interchange Format  |  1996-06-12  |  82KB  |  545x447  |  4-bit (16 colors)
Labels: text | screenshot | parallel | number | font | line | display
OCR: ESPERANT Query System -[ESPERANT Demo DataView] File Edit Query Options Format Window Help ESPERANT Query Create 'Show .. " Clause SHOW Solasperson Noms AND THE TOTAL Customer Show _Template Batch Balance SORTED BY THE TOTAL Customer Balance CESCENDING Show Borind By With X Of Total Concal Compilation SOL Select From: For Show Clause SELECT TI.NAME, SUM (12.BALANCE) FROM ( @ SALESPEOPLE TI LEFT OUTER JOIN lismes CUSTOMERS 12 ON Customer Chy 51.SALESPERSON#= 2.SALESPERSON# ] Customer Siale GROUP BY TI. NAME Customar Zip Code ORDER BY 2 DESC Crede Limi Customer Balance Haleysenton Nato Results The city portion of the address. Salesperson Nacho : SUM(Customer Balance] PAUL WILLLAME SAY ROGERS 180800 PAM JOHNSON 16450 750 Modis Soluctodf Homs BLL SMITH WENDY JONES THE TOTAL Customer Belanco Deletu Count FIGURE 3 Esperant's Query Assistant lets users build simple or complex queries. Esperant displays the query using its own English-like syntax, and it displays the SQL that it sends to the DBMS. Esperant helps end users avoid in- valid queries by disabling choices or command buttons that do not make sense.